package com.situ.hr4.w.dao;

import com.situ.hr4.pojo.EngageResume;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;
import java.util.Map;

@Mapper
public interface LYdao {
    //全查未录用的信息
    @Select("select a.res_id,a.human_name,a.human_sex,a.human_age,b.major_id,b.major_name \n" +
            "\t,c.major_kind_name,c.major_kind_id,a.human_college,a.human_educated_major\n" +
            "\tfrom engage_resume a inner join config_major b on \n" +
            "\ta.human_major_id=b.major_id inner join config_major_kind c\n" +
            "\ton b.major_kind_id=c.major_kind_id where interview_status=#{value}")
    List<Map> qc(int id);

    //根据id修改面试状态和录用申请审核意见
    @Update("update engage_resume set interview_status=#{interview_status},pass_checkComment=#{pass_checkComment} where res_id=#{res_id}")
    void update(EngageResume e);

    //根据id修改面试状态和录用申请审批意见
    @Update("update engage_resume set interview_status=#{interview_status},pass_passComment=#{pass_passComment} where res_id=#{res_id}")
    void update1(EngageResume e);
}
